Welcome Guest, you are in: • Login

devio dbscript ScrewTurn Wiki

Navigation¶

Main Page

Create Account

Search the wiki
»

PoweredBy

Discuss (0) View Page Code History

dbo ErrorLog (table)

Print

RSS

Modified on 2011/08/27 11:16 by wikibot Categorized as Uncategorized

» dbo ErrorLog (table)

wikibot ¶

Table	dbo.ErrorLog
Description	Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct.

Columns ¶

Column	Data Type	Nullable	Default	Description
ErrorLogID	int	not null		Primary key for ErrorLog records.
ErrorTime	datetime	not null	(getdate())	The date and time at which the error occurred.
UserName	sysname	not null		The user who executed the batch in which the error occurred.
ErrorNumber	int	not null		The error number of the error that occurred.
ErrorSeverity	int	null		The severity of the error that occurred.
ErrorState	int	null		The state number of the error that occurred.
ErrorProcedure	nvarchar(126)	null		The name of the stored procedure or trigger where the error occurred.
ErrorLine	int	null		The line number at which the error occurred.
ErrorMessage	nvarchar(4000)	not null		The message text of the error that occurred.

Primary Key ¶

Primary Key	Columns
PK_ErrorLog_ErrorLogID	ErrorLogID

Dependencies ¶

Reference Type	Object Type	Referencing Object
Insert	Procedure	dbo.uspLogError

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.